Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	24767
Missing cells	24767
Missing cells (%)	7.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.6 MiB
Average record size in memory	112.0 B

Variable types

Numeric	9
Categorical	4
Unsupported	1

Warnings

`is_failed` has constant value "1"	Constant
`customer_id` has a high cardinality: 15892 distinct values	High cardinality
`order_date` has a high cardinality: 734 distinct values	High cardinality
`is_failed` is highly correlated with `payment_id`	High correlation
`payment_id` is highly correlated with `is_failed`	High correlation
`customer_order_rank` has 24767 (100.0%) missing values	Missing
`voucher_amount` is highly skewed (γ1 = 44.89247979)	Skewed
`amount_paid` is highly skewed (γ1 = 44.22375169)	Skewed
`platform_id` is highly skewed (γ1 = -25.89811096)	Skewed
`df_index` has unique values	Unique
`customer_order_rank` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`order_hour` has 392 (1.6%) zeros	Zeros
`voucher_amount` has 23086 (93.2%) zeros	Zeros
`delivery_fee` has 18507 (74.7%) zeros	Zeros

Reproduction

Analysis started	2021-02-25 23:04:09.905636
Analysis finished	2021-02-25 23:04:21.577354
Duration	11.67 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	24767
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	396083.3167
Minimum	160
Maximum	786595
Zeros	0
Zeros (%)	0.0%
Memory size	193.6 KiB

Quantile statistics

Minimum	160
5-th percentile	39104.3
Q1	201279.5
median	395098
Q3	593741
95-th percentile	752565.6
Maximum	786595
Range	786435
Interquartile range (IQR)	392461.5

Descriptive statistics

Standard deviation	227928.2356
Coefficient of variation (CV)	0.5754552793
Kurtosis	-1.194618779
Mean	396083.3167
Median Absolute Deviation (MAD)	195844
Skewness	0.001920806378
Sum	9809795504
Variance	5.19512806 × 10¹⁰
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
131072	1	< 0.1%
171652	1	< 0.1%
130325	1	< 0.1%
386086	1	< 0.1%
118035	1	< 0.1%
394908	1	< 0.1%
763373	1	< 0.1%
120080	1	< 0.1%
339215	1	< 0.1%
42254	1	< 0.1%
Other values (24757)	24757	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
160	1	< 0.1%
226	1	< 0.1%
230	1	< 0.1%
233	1	< 0.1%
246	1	< 0.1%

Value	Count	Frequency (%)
786595	1	< 0.1%
786593	1	< 0.1%
786423	1	< 0.1%
786372	1	< 0.1%
786365	1	< 0.1%

customer_id
Categorical

HIGH CARDINALITY

Distinct	15892
Distinct (%)	64.2%
Missing	0
Missing (%)	0.0%
Memory size	193.6 KiB

d3c48a29c3bb	91
41708e47a759	73
068a8ca306aa	59
9a548f7fef25	55
52ecbd9f90cf	53
Other values (15887)	24436

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	297204
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12067 ?
Unique (%)	48.7%

Sample

1st row	000afe75dc19
2nd row	0011683ab734
3rd row	0011f9b2693b
4th row	0011f9b2693b
5th row	0012b1474694

Value	Count	Frequency (%)
d3c48a29c3bb	91	0.4%
41708e47a759	73	0.3%
068a8ca306aa	59	0.2%
9a548f7fef25	55	0.2%
52ecbd9f90cf	53	0.2%
c43419609296	43	0.2%
894f8ca0d994	39	0.2%
f8b74c17e2f0	37	0.1%
da2c86a726ad	36	0.1%
50df4d1dbeba	34	0.1%
Other values (15882)	24247	97.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
d3c48a29c3bb	91	0.4%
41708e47a759	73	0.3%
068a8ca306aa	59	0.2%
9a548f7fef25	55	0.2%
52ecbd9f90cf	53	0.2%
c43419609296	43	0.2%
894f8ca0d994	39	0.2%
f8b74c17e2f0	37	0.1%
da2c86a726ad	36	0.1%
50df4d1dbeba	34	0.1%
Other values (15882)	24247	97.9%

Most occurring characters

Value	Count	Frequency (%)
4	19161	6.4%
f	19037	6.4%
a	18744	6.3%
e	18665	6.3%
2	18657	6.3%
9	18570	6.2%
8	18557	6.2%
0	18550	6.2%
6	18546	6.2%
1	18541	6.2%
Other values (6)	110176	37.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	185684	62.5%
Lowercase Letter	111520	37.5%

Most frequent character per category

Value	Count	Frequency (%)
4	19161	10.3%
2	18657	10.0%
9	18570	10.0%
8	18557	10.0%
0	18550	10.0%
6	18546	10.0%
1	18541	10.0%
7	18528	10.0%
5	18343	9.9%
3	18231	9.8%

Value	Count	Frequency (%)
f	19037	17.1%
a	18744	16.8%
e	18665	16.7%
c	18417	16.5%
b	18382	16.5%
d	18275	16.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	185684	62.5%
Latin	111520	37.5%

Most frequent character per script

Value	Count	Frequency (%)
4	19161	10.3%
2	18657	10.0%
9	18570	10.0%
8	18557	10.0%
0	18550	10.0%
6	18546	10.0%
1	18541	10.0%
7	18528	10.0%
5	18343	9.9%
3	18231	9.8%

Value	Count	Frequency (%)
f	19037	17.1%
a	18744	16.8%
e	18665	16.7%
c	18417	16.5%
b	18382	16.5%
d	18275	16.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	297204	100.0%

Most frequent character per block

Value	Count	Frequency (%)
4	19161	6.4%
f	19037	6.4%
a	18744	6.3%
e	18665	6.3%
2	18657	6.3%
9	18570	6.2%
8	18557	6.2%
0	18550	6.2%
6	18546	6.2%
1	18541	6.2%
Other values (6)	110176	37.1%

order_date
Categorical

HIGH CARDINALITY

Distinct	734
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Memory size	193.6 KiB

2016-11-24	160
2016-10-03	146
2015-04-28	141
2017-01-01	127
2015-03-27	109
Other values (729)	24084

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	247670
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	2015-06-03
2nd row	2017-02-05
3rd row	2016-09-01
4th row	2016-09-05
5th row	2017-02-12

Value	Count	Frequency (%)
2016-11-24	160	0.6%
2016-10-03	146	0.6%
2015-04-28	141	0.6%
2017-01-01	127	0.5%
2015-03-27	109	0.4%
2016-08-28	103	0.4%
2016-12-24	102	0.4%
2015-08-04	99	0.4%
2016-11-13	99	0.4%
2016-09-04	96	0.4%
Other values (724)	23585	95.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
2016-11-24	160	0.6%
2016-10-03	146	0.6%
2015-04-28	141	0.6%
2017-01-01	127	0.5%
2015-03-27	109	0.4%
2016-08-28	103	0.4%
2016-12-24	102	0.4%
2015-08-04	99	0.4%
2016-11-13	99	0.4%
2016-09-04	96	0.4%
Other values (724)	23585	95.2%

Most occurring characters

Value	Count	Frequency (%)
0	54442	22.0%
-	49534	20.0%
1	47333	19.1%
2	40298	16.3%
6	19761	8.0%
5	10729	4.3%
7	7353	3.0%
3	5131	2.1%
8	4605	1.9%
4	4273	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	198136	80.0%
Dash Punctuation	49534	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	54442	27.5%
1	47333	23.9%
2	40298	20.3%
6	19761	10.0%
5	10729	5.4%
7	7353	3.7%
3	5131	2.6%
8	4605	2.3%
4	4273	2.2%
9	4211	2.1%

Value	Count	Frequency (%)
-	49534	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	247670	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	54442	22.0%
-	49534	20.0%
1	47333	19.1%
2	40298	16.3%
6	19761	8.0%
5	10729	4.3%
7	7353	3.0%
3	5131	2.1%
8	4605	1.9%
4	4273	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	247670	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	54442	22.0%
-	49534	20.0%
1	47333	19.1%
2	40298	16.3%
6	19761	8.0%
5	10729	4.3%
7	7353	3.0%
3	5131	2.1%
8	4605	1.9%
4	4273	1.7%

order_hour
Real number (ℝ_≥0)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	17.2271571
Minimum	0
Maximum	23
Zeros	392
Zeros (%)	1.6%
Memory size	193.6 KiB

Quantile statistics

Minimum	0
5-th percentile	10
Q1	15
median	18
Q3	20
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.455628025
Coefficient of variation (CV)	0.2586397743
Kurtosis	3.986340157
Mean	17.2271571
Median Absolute Deviation (MAD)	2
Skewness	-1.746123381
Sum	426665
Variance	19.8526211
Monotocity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
19	3456	14.0%
20	3195	12.9%
18	3037	12.3%
21	2419	9.8%
17	2200	8.9%
22	1768	7.1%
16	1433	5.8%
14	1168	4.7%
15	1151	4.6%
13	1051	4.2%
Other values (14)	3889	15.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	392	1.6%
1	236	1.0%
2	113	0.5%
3	71	0.3%
4	24	0.1%

Value	Count	Frequency (%)
23	900	3.6%
22	1768	7.1%
21	2419	9.8%
20	3195	12.9%
19	3456	14.0%

customer_order_rank
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	24767
Missing (%)	100.0%
Memory size	193.6 KiB

is_failed
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.6 KiB

1	24767

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	24767
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Value	Count	Frequency (%)
1	24767	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	24767	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	24767	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	24767	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	24767	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24767	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	24767	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24767	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	24767	100.0%

voucher_amount
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	193
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1482235854
Minimum	0
Maximum	93.3989
Zeros	23086
Zeros (%)	93.2%
Memory size	193.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1.029
Maximum	93.3989
Range	93.3989
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.090932377
Coefficient of variation (CV)	7.360045796
Kurtosis	3291.572191
Mean	0.1482235854
Median Absolute Deviation (MAD)	0
Skewness	44.89247979
Sum	3671.05354
Variance	1.19013345
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	23086	93.2%
1.029	476	1.9%
2.058	357	1.4%
1.715	286	1.2%
0.686	134	0.5%
1.372	58	0.2%
2.744	51	0.2%
2.5725	43	0.2%
5.145	42	0.2%
3.43	10	< 0.1%
Other values (183)	224	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	23086	93.2%
0.00343	2	< 0.1%
0.41846	1	< 0.1%
0.5145	7	< 0.1%
0.61054	1	< 0.1%

Value	Count	Frequency (%)
93.3989	1	< 0.1%
78.02907	1	< 0.1%
33.39791	1	< 0.1%
27.80358	1	< 0.1%
24.15406	1	< 0.1%

delivery_fee
Real number (ℝ_≥0)

ZEROS

Distinct	69
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.2114688735
Minimum	0
Maximum	9.86
Zeros	18507
Zeros (%)	74.7%
Memory size	193.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.2465
95-th percentile	0.986
Maximum	9.86
Range	9.86
Interquartile range (IQR)	0.2465

Descriptive statistics

Standard deviation	0.4319605626
Coefficient of variation (CV)	2.042667346
Kurtosis	20.30196018
Mean	0.2114688735
Median Absolute Deviation (MAD)	0
Skewness	2.961695917
Sum	5237.44959
Variance	0.1865899276
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18507	74.7%
0.493	2036	8.2%
0.986	1197	4.8%
0.7395	1077	4.3%
1.4297	391	1.6%
1.479	312	1.3%
1.2325	252	1.0%
0.2465	206	0.8%
0.46835	108	0.4%
1.7255	71	0.3%
Other values (59)	610	2.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	18507	74.7%
0.0493	1	< 0.1%
0.0986	3	< 0.1%
0.1479	7	< 0.1%
0.22185	3	< 0.1%

Value	Count	Frequency (%)
9.86	1	< 0.1%
6.6555	1	< 0.1%
5.916	1	< 0.1%
4.93	3	< 0.1%
3.944	3	< 0.1%

amount_paid
Real number (ℝ_≥0)

SKEWED

Distinct	2533
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10.55155809
Minimum	0
Maximum	1131.03
Zeros	46
Zeros (%)	0.2%
Memory size	193.6 KiB

Quantile statistics

Minimum	0
5-th percentile	4.248
Q1	6.372
median	8.7615
Q3	12.056355
95-th percentile	21.2931
Maximum	1131.03
Range	1131.03
Interquartile range (IQR)	5.684355

Descriptive statistics

Standard deviation	11.79499819
Coefficient of variation (CV)	1.117844216
Kurtosis	3610.45244
Mean	10.55155809
Median Absolute Deviation (MAD)	2.655
Skewness	44.22375169
Sum	261330.4393
Variance	139.1219822
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.31	576	2.3%
7.965	519	2.1%
6.372	409	1.7%
5.841	362	1.5%
8.496	327	1.3%
10.62	321	1.3%
6.903	308	1.2%
5.5755	294	1.2%
9.027	284	1.1%
6.6375	277	1.1%
Other values (2523)	21090	85.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	46	0.2%
0.01593	1	< 0.1%
0.0531	1	< 0.1%
0.17523	1	< 0.1%
0.23895	1	< 0.1%

Value	Count	Frequency (%)
1131.03	1	< 0.1%
581.7105	1	< 0.1%
363.01815	1	< 0.1%
353.3805	1	< 0.1%
246.88845	1	< 0.1%

restaurant_id
Real number (ℝ_≥0)

Distinct	7946
Distinct (%)	32.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	174489029.2
Minimum	73498
Maximum	339823498
Zeros	0
Zeros (%)	0.0%
Memory size	193.6 KiB

Quantile statistics

Minimum	73498
5-th percentile	31483498
Q1	96423498
median	184773498
Q3	243643498
95-th percentile	304893498
Maximum	339823498
Range	339750000
Interquartile range (IQR)	147220000

Descriptive statistics

Standard deviation	88454059.81
Coefficient of variation (CV)	0.5069319271
Kurtosis	-1.086619904
Mean	174489029.2
Median Absolute Deviation (MAD)	72620000
Skewness	-0.1783513105
Sum	4.321569785 × 10¹²
Variance	7.824120697 × 10¹⁵
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48073498	74	0.3%
154543498	50	0.2%
88773498	39	0.2%
159773498	36	0.1%
227243498	35	0.1%
305593498	34	0.1%
54923498	32	0.1%
66433498	31	0.1%
183843498	30	0.1%
78013498	29	0.1%
Other values (7936)	24377	98.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
73498	1	< 0.1%
123498	1	< 0.1%
153498	1	< 0.1%
173498	1	< 0.1%
193498	1	< 0.1%

Value	Count	Frequency (%)
339823498	1	< 0.1%
338633498	1	< 0.1%
338123498	1	< 0.1%
338053498	1	< 0.1%
337573498	1	< 0.1%

city_id
Real number (ℝ_≥0)

Distinct	1674
Distinct (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	47062.55312
Minimum	230
Maximum	100048
Zeros	0
Zeros (%)	0.0%
Memory size	193.6 KiB

Quantile statistics

Minimum	230
5-th percentile	10346
Q1	24929.5
median	46276
Q3	67290
95-th percentile	90633
Maximum	100048
Range	99818
Interquartile range (IQR)	42360.5

Descriptive statistics

Standard deviation	25751.38346
Coefficient of variation (CV)	0.5471735331
Kurtosis	-0.9935263223
Mean	47062.55312
Median Absolute Deviation (MAD)	21108
Skewness	0.05639879334
Sum	1165598253
Variance	663133750.2
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10346	2839	11.5%
20326	1124	4.5%
80562	1081	4.4%
50898	588	2.4%
60537	554	2.2%
40441	527	2.1%
44366	475	1.9%
90633	377	1.5%
45358	318	1.3%
47282	306	1.2%
Other values (1664)	16578	66.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
230	38	0.2%
1298	185	0.7%
1676	3	< 0.1%
1689	1	< 0.1%
1699	1	< 0.1%

Value	Count	Frequency (%)
100048	1	< 0.1%
99983	3	< 0.1%
99965	24	0.1%
99856	1	< 0.1%
99841	1	< 0.1%

payment_id
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	193.6 KiB

1779	10951
1619	7319
1491	3657
1811	2592
1523	248

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	99068
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1779
2nd row	1811
3rd row	1779
4th row	1779
5th row	1779

Value	Count	Frequency (%)
1779	10951	44.2%
1619	7319	29.6%
1491	3657	14.8%
1811	2592	10.5%
1523	248	1.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
1779	10951	44.2%
1619	7319	29.6%
1491	3657	14.8%
1811	2592	10.5%
1523	248	1.0%

Most occurring characters

Value	Count	Frequency (%)
1	40927	41.3%
9	21927	22.1%
7	21902	22.1%
6	7319	7.4%
4	3657	3.7%
8	2592	2.6%
5	248	0.3%
2	248	0.3%
3	248	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	99068	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	40927	41.3%
9	21927	22.1%
7	21902	22.1%
6	7319	7.4%
4	3657	3.7%
8	2592	2.6%
5	248	0.3%
2	248	0.3%
3	248	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	99068	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	40927	41.3%
9	21927	22.1%
7	21902	22.1%
6	7319	7.4%
4	3657	3.7%
8	2592	2.6%
5	248	0.3%
2	248	0.3%
3	248	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	99068	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	40927	41.3%
9	21927	22.1%
7	21902	22.1%
6	7319	7.4%
4	3657	3.7%
8	2592	2.6%
5	248	0.3%
2	248	0.3%
3	248	0.3%

platform_id
Real number (ℝ_≥0)

SKEWED

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	29889.68922
Minimum	525
Maximum	30423
Zeros	0
Zeros (%)	0.0%
Memory size	193.6 KiB

Quantile statistics

Minimum	525
5-th percentile	29463
Q1	29463
median	29815
Q3	30231
95-th percentile	30359
Maximum	30423
Range	29898
Interquartile range (IQR)	768

Descriptive statistics

Standard deviation	955.3340507
Coefficient of variation (CV)	0.03196199343
Kurtosis	791.0017466
Mean	29889.68922
Median Absolute Deviation (MAD)	352
Skewness	-25.89811096
Sum	740277933
Variance	912663.1485
Monotocity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
29463	8037	32.5%
30231	7637	30.8%
29815	4338	17.5%
30359	3274	13.2%
30391	676	2.7%
29751	410	1.7%
29495	175	0.7%
30423	103	0.4%
30199	70	0.3%
525	22	0.1%
Other values (3)	25	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
525	22	0.1%
22167	1	< 0.1%
22263	4	< 0.1%
29463	8037	32.5%
29495	175	0.7%

Value	Count	Frequency (%)
30423	103	0.4%
30391	676	2.7%
30359	3274	13.2%
30231	7637	30.8%
30199	70	0.3%

transmission_id
Real number (ℝ_≥0)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2220.000323
Minimum	212
Maximum	21124
Zeros	0
Zeros (%)	0.0%
Memory size	193.6 KiB

Quantile statistics

Minimum	212
5-th percentile	212
Q1	212
median	212
Q3	4324
95-th percentile	4356
Maximum	21124
Range	20912
Interquartile range (IQR)	4112

Descriptive statistics

Standard deviation	2058.199582
Coefficient of variation (CV)	0.9271167939
Kurtosis	-1.712491168
Mean	2220.000323
Median Absolute Deviation (MAD)	0
Skewness	0.07884075779
Sum	54982748
Variance	4236185.519
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
212	12666	51.1%
4356	5617	22.7%
4228	3163	12.8%
4324	2980	12.0%
4260	163	0.7%
4996	144	0.6%
4196	32	0.1%
2020	1	< 0.1%
21124	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
212	12666	51.1%
2020	1	< 0.1%
4196	32	0.1%
4228	3163	12.8%
4260	163	0.7%

Value	Count	Frequency (%)
21124	1	< 0.1%
4996	144	0.6%
4356	5617	22.7%
4324	2980	12.0%
4260	163	0.7%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	customer_id	order_date	order_hour	customer_order_rank	is_failed	voucher_amount	delivery_fee	amount_paid	restaurant_id	city_id	payment_id	platform_id	transmission_id
0	160	000afe75dc19	2015-06-03	21	NaN	1	0.000	0.00000	7.43400	161043498	97301	1779	29751	4356
1	226	0011683ab734	2017-02-05	18	NaN	1	1.029	1.23250	8.76150	274713498	64562	1811	30231	212
2	230	0011f9b2693b	2016-09-01	14	NaN	1	0.000	0.98107	14.00247	159553498	39335	1779	29463	212
3	233	0011f9b2693b	2016-09-05	11	NaN	1	0.000	0.98600	8.76150	187213498	39335	1779	29463	212
4	246	0012b1474694	2017-02-12	18	NaN	1	0.000	0.00000	10.03590	317543498	24334	1779	29463	212
5	259	00144f5638a1	2016-05-20	0	NaN	1	0.000	0.00000	5.84100	47643498	28426	1523	29815	4324
6	312	001a947e5f30	2015-11-29	14	NaN	1	0.000	1.42970	12.31920	145893498	80562	1779	29815	212
7	334	001ae9f68533	2017-01-31	20	NaN	1	0.000	0.73950	7.22160	307033498	45358	1779	29463	212
8	558	00337d8863ff	2016-06-16	21	NaN	1	0.000	0.73950	12.47850	218843498	38407	1811	30231	212
9	568	003405d5944f	2017-02-26	17	NaN	1	0.000	0.49300	22.14270	184463498	63717	1619	29463	4356

Last rows

	df_index	customer_id	order_date	order_hour	customer_order_rank	is_failed	amount_paid	restaurant_id	city_id	payment_id	platform_id	transmission_id
24757	786349	ffe2a6942fd2	2015-08-17	19	NaN	1	4.5135	76643498	79770	1811	30231	212
24758	786350	ffe2a6942fd2	2015-08-17	19	NaN	1	6.0534	76643498	79770	1811	30231	212
24759	786358	ffe2a6942fd2	2015-10-08	20	NaN	1	11.1510	188273498	79920	1811	30231	212
24760	786359	ffe2a6942fd2	2015-10-11	20	NaN	1	7.9650	84663498	79920	1811	30231	212
24761	786364	ffe2a6942fd2	2015-11-23	21	NaN	1	7.9650	84663498	79920	1779	29463	212
24762	786365	ffe2a6942fd2	2015-11-23	21	NaN	1	7.9650	84663498	79920	1779	30231	212
24763	786372	ffe2a6942fd2	2016-01-28	21	NaN	1	9.2925	84663498	79920	1779	30231	212
24764	786423	ffe7577807b8	2016-10-03	21	NaN	1	7.6995	131513498	73661	1779	30231	212
24765	786593	fffe9d5a8d41	2016-07-31	21	NaN	1	8.4429	156133498	10346	1811	29463	212
24766	786595	fffe9d5a8d41	2016-09-30	20	NaN	1	10.7262	983498	10346	1779	29463	212

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows